Tabela TRStudyDetails

Definicja tabeli TRStudyDetails

Name

TRStudyDetails

Code

TRStudyDetails

Comment

 


Lista kolumn tabeli TRStudyDetails

Name

Code

StuInsUID

StuInsUID

StudyID

StudyID

RemoteStation

RemoteStation

LastUpdate

LastUpdate

DcmImagesNo

DcmImagesNo

AllStudyFilesNo

AllStudyFilesNo

sendingStatus

sendingStatus

CompletedDate

CompletedDate

ProtocolVersion

ProtocolVersion

VpnIP

VpnIP

VpnKeyName

VpnKeyName

PublicIP

PublicIP


Kolumna StuInsUID tabeli TRStudyDetails

Definicja kolumny StuInsUID tabeli TRStudyDetails

Name

StuInsUID

Code

StuInsUID

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna StudyID tabeli TRStudyDetails

Definicja kolumny StudyID tabeli TRStudyDetails

Name

StudyID

Code

StudyID

Data Type

VARCHAR2(15)

Mandatory

Yes

Comment

 


Kolumna RemoteStation tabeli TRStudyDetails

Definicja kolumny RemoteStation tabeli TRStudyDetails

Name

RemoteStation

Code

RemoteStation

Data Type

VARCHAR2(12)

Mandatory

Yes

Comment

 


Kolumna LastUpdate tabeli TRStudyDetails

Definicja kolumny LastUpdate tabeli TRStudyDetails

Name

LastUpdate

Code

LastUpdate

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna DcmImagesNo tabeli TRStudyDetails

Definicja kolumny DcmImagesNo tabeli TRStudyDetails

Name

DcmImagesNo

Code

DcmImagesNo

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AllStudyFilesNo tabeli TRStudyDetails

Definicja kolumny AllStudyFilesNo tabeli TRStudyDetails

Name

AllStudyFilesNo

Code

AllStudyFilesNo

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna sendingStatus tabeli TRStudyDetails

Definicja kolumny sendingStatus tabeli TRStudyDetails

Name

sendingStatus

Code

sendingStatus

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CompletedDate tabeli TRStudyDetails

Definicja kolumny CompletedDate tabeli TRStudyDetails

Name

CompletedDate

Code

CompletedDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ProtocolVersion tabeli TRStudyDetails

Definicja kolumny ProtocolVersion tabeli TRStudyDetails

Name

ProtocolVersion

Code

ProtocolVersion

Data Type

VARCHAR2(8)

Mandatory

No

Comment

 


Kolumna VpnIP tabeli TRStudyDetails

Definicja kolumny VpnIP tabeli TRStudyDetails

Name

VpnIP

Code

VpnIP

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna VpnKeyName tabeli TRStudyDetails

Definicja kolumny VpnKeyName tabeli TRStudyDetails

Name

VpnKeyName

Code

VpnKeyName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna PublicIP tabeli TRStudyDetails

Definicja kolumny PublicIP tabeli TRStudyDetails

Name

PublicIP

Code

PublicIP

Data Type

VARCHAR2(22)

Mandatory

No

Comment

 


Lista kluczy tabeli TRStudyDetails

Name

Code

Primary

TRStudyDet_StuIns_5140978412

TRStudyDet_StuIns_5140978412

X


Klucz TRStudyDet_StuIns_5140978412 tabeli TRStudyDetails

Definicja klucza TRStudyDet_StuIns_5140978412 tabeli TRStudyDetails

Name

TRStudyDet_StuIns_5140978412

Code

TRStudyDet_StuIns_5140978412

Primary

Yes

Comment